package dao.member;

import vo.MemberVO;

public interface MemberDAO {
	
	/**
	 * 메일로 패스를 찾아 옴. 있으면 넘어오고 없으면 null
	 * @param member_mail
	 * @return member_no, member_pass, majorunit_no, member_certify
	 */
	public MemberVO login(String member_mail) throws Exception;

	/**
	 * 기존에 있는 메일인가.
	 * @param member_mail
	 * @return 있으면 1, 없으면 0
	 */
	public int isMember(String member_mail) throws Exception;

	/**
	 * 회원가입
	 * @param param String member_mail, String member_pass
	 * @return 시퀀스값
	 */
	public int registerMember(MemberVO param) throws Exception;
	
	/**
	 * 비밀번호 변경. 0이 날아온다면 없는 mail
	 * @param param String member_mail, String member_pass
	 * @return 있으면 1, 없으면 0
	 */
	public int updatePass(MemberVO param) throws Exception;

	/**
	 * 멤버 탈퇴. delete를 1로.
	 * @param member_no
	 */
	public void deleteMember(int member_no) throws Exception;
}
